Release 10.1A: OpenEdge Getting Started:
Progress OpenEdge Studio

Creating and connecting to the Sports2000 database

Before running or assembling the sample application described in this chapter, you must create a copy of the Sports2000 database and connect to it.

To complete this task, you use the Data Dictionary tool. The Data Dictionary is part of the OpenEdge Studio. With it, you can create and connect to databases, as well as edit the definitions of tables, fields, indexes, and other database-related information.

Making a copy of the Sports2000 database allows you to make changes to the copy while preserving the original database unchanged for future use. You can also replace your working copy using the Replace If Exists option.

To create and connect to your copy of the Sports2000 database:

Choose Programs OpenEdge Desktop fromthe Windows Start menu.
Choose the Data Dictionary icon from the Desktop.
When you run the Data Dictionary, it looks for a connected database. If there is no connected database, the Dictionary Startup dialog box appears:



Select Create a New Database and choose OK. The default selection for the Dictionary Startup dialog box is Connect to an Existing Database. The Create Database dialog box appears:



Type <wrk>\databases\sports2000.db for the New Physical Database Name, where <wrk> is your OpenEdge working directory.
Select A Copy of Some Other Database in the Start with radio set. The default selection is An EMPTY Database.
Choose the Files button, browse to the location of the original Sports2000 database, and select it.
Note: The Sports2000 database is located in your OpenEdge installation directory. By default, this is C:\Progress\OpenEdge.
Choose OK.

The Data Dictionary creates a copy of the Sports2000 database in your working directory. The Connect Database dialog box appears and displays the name of the database you just created:



Choose OK in the Connect Database dialog box. The Data Dictionary makes the connection and its startup window appears:



You have now created and connected to your working copy of the Sports2000 database. The Data Dictionary window shows the Sports2000 database and the tables in the database.

The icons in the toolbar govern what you can do with the Data Dictionary and what information displays for the selected database. When you choose an icon, buttons for varying tasks appear at the bottom of the window. Table 2–1 lists the icons and their associated displays and tasks.

Table 2–1: Data Dictionary icons 

Icon	Displays	Available task buttons
	Connected databases	Create Database Database Properties
	Tables in selected database	Create Table Table Properties Delete Table
	Sequences in selected database	Create Sequence Sequence Properties Delete Sequence
	Fields in selected table	Create Field Field Properties Delete Field
	Indexes on selected table	Create Index Index Properties Delete Index

Use the Data Dictionary to familiarize yourself with the structure of the Sports2000 database.
When you are ready, close the Data Dictionary and return to the Desktop.